package jsyf.oa.entity.device;

import com.alibaba.fastjson.JSONObject;
import jsyf.oa.entity.attach.AttachmentEntity;
import jsyf.oa.ientity.BaseEntity;

import javax.persistence.Entity;
import javax.persistence.Table;
import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

/**
 * Created by y on 2018/7/3.
 */
@Entity
@Table(name = "T_DVC_DISPLACE", schema = "oa", catalog = "")
public class DeviceDisplaceEntity extends BaseEntity {
    /*设备信息*/
    private String fkCompanyId = "";
    private String companyName = "";//归属公司名称
    private String houseName = "";//房屋名称
    private String houseAddress = "";//房屋位置
    private String state = "";//状态
    private String buildingNumber = "";//房屋楼号单元
    private String area = "";//房屋面积
    private String remark = "";//备注
    private String brandName = "";//品牌名称
    private String modelName = "";//型号名称
    private String storeAddress = "";//存放地，库存地
    private String sequence = "";//序列号
    private String factoryDate = "";//旧机/汽车/出厂日期,房屋年代
    private String replacementId = "";//合同置换表ID
    private String manufacturer = "";//置换设备生产商
    private String replacementType = "";//设备类型/汽车类型/房屋类型
    private String housesProperty = "";//房屋产权年限
    private String replacementsName = "";//合同中置换类型的名称（用，分割）
    private Integer type = 0;//1-旧机，2-汽车，3-房屋
    private BigDecimal hours = new BigDecimal("0.00");//小时数
    private BigDecimal kilometers = new BigDecimal("0.00");//公里数
    private BigDecimal replacementPrice = new BigDecimal("0.00");//置换价格
    private BigDecimal replacementSubsidy = new BigDecimal("0.00");//置换补贴
    private BigDecimal estimatePrice = new BigDecimal("0.00");//评估价格
    private String regionId = "";
    private String regionName = "";
    private String regionManagerId = "";
    private String regionManagerName = "";
    private String bigregionManagerId = "";
    private String bigregionManagerName = "";
    private BigDecimal sellPrice = new BigDecimal("0.00");//出售价格
    private String transfer = "";//是否可过户
    private String otherCondition = "";//合同里的其他情况
    private String deviceAnnexName = "";//设备信息附件
    private String deviceAnnexUrl = "";//设备信息附件
    private List<AttachmentEntity> attaches;//多个附件
    private List<AttachmentEntity> devicePictures;//多个附件
    private String whetherToClose = "";//合同是否成交（0-未成交，1-已成交）
    /*运输信息*/
    private String departure = "";
    private String departureContactName = "";
    private String departureContactTel = "";
    private String destination = "";
    private String destinationContactName = "";
    private String destinationContactTel = "";
    private String transportCompany = "";
    private String traComContactName = "";
    private String traComContactTel = "";
    private String modelCarLicense = "";
    private String driverName = "";
    private String driverTel = "";
    private String deduction = "";
    private String deductionInstructions = "";
    private String modelCarPhotoName = "";
    private String modelCarPhotoUrl = "";
    private String driverCertificateName = "";
    private String driverCertificateUrl = "";
    private String devicePhotoName = "";
    private String devicePhotoUrl = "";
    private Integer transportState = 0;
    private List<AttachmentEntity> hourseAnnex;//房屋多个附件
    private String insuranceExpirationDate;//保险到期日
    private String frameNumber;//车架号


    private String exhibitionPromotion = "";//展会促销
    private String giftDetails = "";//赠送明细
    private String expenseDescription = "";//费用说明
    private BigDecimal trainingFee = new BigDecimal("0.00");//培训费
    private BigDecimal netTransactionPrice = new BigDecimal("0.00");//成交净价
    private String accessoryGift = "";//配件赠送
    private BigDecimal otherFee = new BigDecimal("0.00");//其他费用
    private BigDecimal freight = new BigDecimal("0.00");//运费
    private BigDecimal companyLimitPrice = new BigDecimal("0.00");//公司限价
    private Integer replacementNumber = 1;//置换数量
    private String priceOffer = "";//价格优惠说明

    /*审核信息*/
    private String auditName;
    private String auditId;
    private Integer auditFlag;
    private String createUserId;
    private String createUserName;
    private String updateUserId;
    private String updateUserName;
    private String auditAdvise;
    private String auditRoleName;
    private Date auditTime;


    private String recentContactDate;
    private String latestWorkingHours;
    private String deviceSource;
    private String warrantyState;
    private String administratorName;
    private String administratorPhone;
    private String operatorName;
    private String operatorPhone;
    private String servicePersonnel;
    private String engineNumber;
    private String nextServiceDate;
    private String cooperationType;
    private BigDecimal lossMoney = new BigDecimal("0.00");//亏损
    private BigDecimal fundPossessionCost = new BigDecimal("0.00");//资金占用费

    //置换新机信息
    private String customerName;
    private String replacementDeviceModelName;
    private String replacementDeviceBrandName;
    private String replacementDeviceSequence;

    public String getCustomerName() {
        return customerName;
    }

    public void setCustomerName(String customerName) {
        this.customerName = customerName;
    }

    public String getReplacementDeviceModelName() {
        return replacementDeviceModelName;
    }

    public void setReplacementDeviceModelName(String replacementDeviceModelName) {
        this.replacementDeviceModelName = replacementDeviceModelName;
    }

    public String getReplacementDeviceBrandName() {
        return replacementDeviceBrandName;
    }

    public void setReplacementDeviceBrandName(String replacementDeviceBrandName) {
        this.replacementDeviceBrandName = replacementDeviceBrandName;
    }

    public String getReplacementDeviceSequence() {
        return replacementDeviceSequence;
    }

    public void setReplacementDeviceSequence(String replacementDeviceSequence) {
        this.replacementDeviceSequence = replacementDeviceSequence;
    }

    public BigDecimal getLossMoney() {
        return lossMoney;
    }

    public void setLossMoney(BigDecimal lossMoney) {
        this.lossMoney = lossMoney;
    }

    public BigDecimal getFundPossessionCost() {
        return fundPossessionCost;
    }

    public void setFundPossessionCost(BigDecimal fundPossessionCost) {
        this.fundPossessionCost = fundPossessionCost;
    }

    public String getCooperationType() {
        return cooperationType;
    }

    public void setCooperationType(String cooperationType) {
        this.cooperationType = cooperationType;
    }

    public String getRecentContactDate() {
        return recentContactDate;
    }

    public void setRecentContactDate(String recentContactDate) {
        this.recentContactDate = recentContactDate;
    }

    public String getLatestWorkingHours() {
        return latestWorkingHours;
    }

    public void setLatestWorkingHours(String latestWorkingHours) {
        this.latestWorkingHours = latestWorkingHours;
    }

    public String getDeviceSource() {
        return deviceSource;
    }

    public void setDeviceSource(String deviceSource) {
        this.deviceSource = deviceSource;
    }

    public String getWarrantyState() {
        return warrantyState;
    }

    public void setWarrantyState(String warrantyState) {
        this.warrantyState = warrantyState;
    }

    public String getAdministratorName() {
        return administratorName;
    }

    public void setAdministratorName(String administratorName) {
        this.administratorName = administratorName;
    }

    public String getAdministratorPhone() {
        return administratorPhone;
    }

    public void setAdministratorPhone(String administratorPhone) {
        this.administratorPhone = administratorPhone;
    }

    public String getOperatorName() {
        return operatorName;
    }

    public void setOperatorName(String operatorName) {
        this.operatorName = operatorName;
    }

    public String getOperatorPhone() {
        return operatorPhone;
    }

    public void setOperatorPhone(String operatorPhone) {
        this.operatorPhone = operatorPhone;
    }

    public String getServicePersonnel() {
        return servicePersonnel;
    }

    public void setServicePersonnel(String servicePersonnel) {
        this.servicePersonnel = servicePersonnel;
    }

    public String getEngineNumber() {
        return engineNumber;
    }

    public void setEngineNumber(String engineNumber) {
        this.engineNumber = engineNumber;
    }

    public String getNextServiceDate() {
        return nextServiceDate;
    }

    public void setNextServiceDate(String nextServiceDate) {
        this.nextServiceDate = nextServiceDate;
    }

    public Date getAuditTime() {
        return auditTime;
    }

    public void setAuditTime(Date auditTime) {
        this.auditTime = auditTime;
    }

    public String getAuditRoleName() {
        return auditRoleName;
    }

    public void setAuditRoleName(String auditRoleName) {
        this.auditRoleName = auditRoleName;
    }

    public String getAuditAdvise() {
        return auditAdvise;
    }

    public void setAuditAdvise(String auditAdvise) {
        this.auditAdvise = auditAdvise;
    }

    public String getAuditName() {
        return auditName;
    }

    public void setAuditName(String auditName) {
        this.auditName = auditName;
    }

    public String getAuditId() {
        return auditId;
    }

    public void setAuditId(String auditId) {
        this.auditId = auditId;
    }

    public Integer getAuditFlag() {
        return auditFlag;
    }

    public void setAuditFlag(Integer auditFlag) {
        this.auditFlag = auditFlag;
    }

    public String getCreateUserId() {
        return createUserId;
    }

    public void setCreateUserId(String createUserId) {
        this.createUserId = createUserId;
    }

    public String getCreateUserName() {
        return createUserName;
    }

    public void setCreateUserName(String createUserName) {
        this.createUserName = createUserName;
    }

    public String getUpdateUserId() {
        return updateUserId;
    }

    public void setUpdateUserId(String updateUserId) {
        this.updateUserId = updateUserId;
    }

    public String getUpdateUserName() {
        return updateUserName;
    }

    public void setUpdateUserName(String updateUserName) {
        this.updateUserName = updateUserName;
    }

    public String getRegionName() {
        return regionName;
    }

    public void setRegionName(String regionName) {
        this.regionName = regionName;
    }

    public String getRegionManagerName() {
        return regionManagerName;
    }

    public void setRegionManagerName(String regionManagerName) {
        this.regionManagerName = regionManagerName;
    }

    public String getBigregionManagerName() {
        return bigregionManagerName;
    }

    public void setBigregionManagerName(String bigregionManagerName) {
        this.bigregionManagerName = bigregionManagerName;
    }

    public String getPriceOffer() {
        return priceOffer;
    }

    public void setPriceOffer(String priceOffer) {
        this.priceOffer = priceOffer;
    }

    public Integer getReplacementNumber() {
        return replacementNumber;
    }

    public void setReplacementNumber(Integer replacementNumber) {
        this.replacementNumber = replacementNumber;
    }

    public String getInsuranceExpirationDate() {
        return insuranceExpirationDate;
    }

    public void setInsuranceExpirationDate(String insuranceExpirationDate) {
        this.insuranceExpirationDate = insuranceExpirationDate;
    }

    public String getFrameNumber() {
        return frameNumber;
    }

    public void setFrameNumber(String frameNumber) {
        this.frameNumber = frameNumber;
    }

    public String getFkCompanyId() {
        return fkCompanyId;
    }

    public void setFkCompanyId(String fkCompanyId) {
        this.fkCompanyId = fkCompanyId;
    }

    public String getCompanyName() {
        return companyName;
    }

    public void setCompanyName(String companyName) {
        this.companyName = companyName;
    }

    public String getHouseName() {
        return houseName;
    }

    public List<AttachmentEntity> getHourseAnnex() {
        return hourseAnnex;
    }

    public void setHourseAnnex(List<AttachmentEntity> hourseAnnex) {
        this.hourseAnnex = hourseAnnex;
    }

    public void setHouseName(String houseName) {
        this.houseName = houseName;
    }

    public String getHouseAddress() {
        return houseAddress;
    }

    public void setHouseAddress(String houseAddress) {
        this.houseAddress = houseAddress;
    }

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

    public String getBuildingNumber() {
        return buildingNumber;
    }

    public void setBuildingNumber(String buildingNumber) {
        this.buildingNumber = buildingNumber;
    }

    public String getArea() {
        return area;
    }

    public void setArea(String area) {
        this.area = area;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }

    public String getBrandName() {
        return brandName;
    }

    public void setBrandName(String brandName) {
        this.brandName = brandName;
    }

    public String getModelName() {
        return modelName;
    }

    public void setModelName(String modelName) {
        this.modelName = modelName;
    }

    public String getStoreAddress() {
        return storeAddress;
    }

    public void setStoreAddress(String storeAddress) {
        this.storeAddress = storeAddress;
    }

    public String getSequence() {
        return sequence;
    }

    public void setSequence(String sequence) {
        this.sequence = sequence;
    }

    public String getFactoryDate() {
        return factoryDate;
    }

    public void setFactoryDate(String factoryDate) {
        this.factoryDate = factoryDate;
    }

    public String getReplacementId() {
        return replacementId;
    }

    public void setReplacementId(String replacementId) {
        this.replacementId = replacementId;
    }

    public String getManufacturer() {
        return manufacturer;
    }

    public void setManufacturer(String manufacturer) {
        this.manufacturer = manufacturer;
    }

    public String getReplacementType() {
        return replacementType;
    }

    public void setReplacementType(String replacementType) {
        this.replacementType = replacementType;
    }

    public String getHousesProperty() {
        return housesProperty;
    }

    public void setHousesProperty(String housesProperty) {
        this.housesProperty = housesProperty;
    }

    public String getReplacementsName() {
        return replacementsName;
    }

    public void setReplacementsName(String replacementsName) {
        this.replacementsName = replacementsName;
    }

    public Integer getType() {
        return type;
    }

    public void setType(Integer type) {
        this.type = type;
    }

    public BigDecimal getHours() {
        return hours;
    }

    public void setHours(BigDecimal hours) {
        this.hours = hours;
    }

    public BigDecimal getKilometers() {
        return kilometers;
    }

    public void setKilometers(BigDecimal kilometers) {
        this.kilometers = kilometers;
    }

    public BigDecimal getReplacementPrice() {
        return replacementPrice;
    }

    public void setReplacementPrice(BigDecimal replacementPrice) {
        this.replacementPrice = replacementPrice;
    }

    public BigDecimal getReplacementSubsidy() {
        return replacementSubsidy;
    }

    public void setReplacementSubsidy(BigDecimal replacementSubsidy) {
        this.replacementSubsidy = replacementSubsidy;
    }

    public BigDecimal getEstimatePrice() {
        return estimatePrice;
    }

    public void setEstimatePrice(BigDecimal estimatePrice) {
        this.estimatePrice = estimatePrice;
    }

    public String getRegionId() {
        return regionId;
    }

    public void setRegionId(String regionId) {
        this.regionId = regionId;
    }

    public String getRegionManagerId() {
        return regionManagerId;
    }

    public void setRegionManagerId(String regionManagerId) {
        this.regionManagerId = regionManagerId;
    }

    public String getBigregionManagerId() {
        return bigregionManagerId;
    }

    public void setBigregionManagerId(String bigregionManagerId) {
        this.bigregionManagerId = bigregionManagerId;
    }

    public BigDecimal getSellPrice() {
        return sellPrice;
    }

    public void setSellPrice(BigDecimal sellPrice) {
        this.sellPrice = sellPrice;
    }

    public String getTransfer() {
        return transfer;
    }

    public void setTransfer(String transfer) {
        this.transfer = transfer;
    }

    public String getOtherCondition() {
        return otherCondition;
    }

    public void setOtherCondition(String otherCondition) {
        this.otherCondition = otherCondition;
    }

    public String getDeviceAnnexName() {
        return deviceAnnexName;
    }

    public void setDeviceAnnexName(String deviceAnnexName) {
        this.deviceAnnexName = deviceAnnexName;
    }

    public String getDeviceAnnexUrl() {
        return deviceAnnexUrl;
    }

    public void setDeviceAnnexUrl(String deviceAnnexUrl) {
        this.deviceAnnexUrl = deviceAnnexUrl;
    }
    /*运输信息*/

    public String getDeparture() {
        return departure;
    }

    public void setDeparture(String departure) {
        this.departure = departure;
    }

    public String getDepartureContactName() {
        return departureContactName;
    }

    public void setDepartureContactName(String departureContactName) {
        this.departureContactName = departureContactName;
    }

    public String getDepartureContactTel() {
        return departureContactTel;
    }

    public void setDepartureContactTel(String departureContactTel) {
        this.departureContactTel = departureContactTel;
    }

    public String getDestination() {
        return destination;
    }

    public void setDestination(String destination) {
        this.destination = destination;
    }

    public String getDestinationContactName() {
        return destinationContactName;
    }

    public void setDestinationContactName(String destinationContactName) {
        this.destinationContactName = destinationContactName;
    }

    public String getDestinationContactTel() {
        return destinationContactTel;
    }

    public void setDestinationContactTel(String destinationContactTel) {
        this.destinationContactTel = destinationContactTel;
    }

    public String getTransportCompany() {
        return transportCompany;
    }

    public void setTransportCompany(String transportCompany) {
        this.transportCompany = transportCompany;
    }

    public String getTraComContactName() {
        return traComContactName;
    }

    public void setTraComContactName(String traComContactName) {
        this.traComContactName = traComContactName;
    }

    public String getTraComContactTel() {
        return traComContactTel;
    }

    public void setTraComContactTel(String traComContactTel) {
        this.traComContactTel = traComContactTel;
    }

    public String getModelCarLicense() {
        return modelCarLicense;
    }

    public void setModelCarLicense(String modelCarLicense) {
        this.modelCarLicense = modelCarLicense;
    }

    public String getDriverName() {
        return driverName;
    }

    public void setDriverName(String driverName) {
        this.driverName = driverName;
    }

    public String getDriverTel() {
        return driverTel;
    }

    public void setDriverTel(String driverTel) {
        this.driverTel = driverTel;
    }

    public String getDeduction() {
        return deduction;
    }

    public void setDeduction(String deduction) {
        this.deduction = deduction;
    }

    public String getDeductionInstructions() {
        return deductionInstructions;
    }

    public void setDeductionInstructions(String deductionInstructions) {
        this.deductionInstructions = deductionInstructions;
    }

    public String getModelCarPhotoName() {
        return modelCarPhotoName;
    }

    public void setModelCarPhotoName(String modelCarPhotoName) {
        this.modelCarPhotoName = modelCarPhotoName;
    }

    public String getModelCarPhotoUrl() {
        return modelCarPhotoUrl;
    }

    public void setModelCarPhotoUrl(String modelCarPhotoUrl) {
        this.modelCarPhotoUrl = modelCarPhotoUrl;
    }

    public String getDriverCertificateName() {
        return driverCertificateName;
    }

    public void setDriverCertificateName(String driverCertificateName) {
        this.driverCertificateName = driverCertificateName;
    }

    public String getDriverCertificateUrl() {
        return driverCertificateUrl;
    }

    public void setDriverCertificateUrl(String driverCertificateUrl) {
        this.driverCertificateUrl = driverCertificateUrl;
    }

    public String getDevicePhotoName() {
        return devicePhotoName;
    }

    public void setDevicePhotoName(String devicePhotoName) {
        this.devicePhotoName = devicePhotoName;
    }

    public String getDevicePhotoUrl() {
        return devicePhotoUrl;
    }

    public void setDevicePhotoUrl(String devicePhotoUrl) {
        this.devicePhotoUrl = devicePhotoUrl;
    }

    public Integer getTransportState() {
        return transportState;
    }

    public void setTransportState(Integer transportState) {
        this.transportState = transportState;
    }

    public List<AttachmentEntity> getAttaches() {
        return attaches;
    }

    public void setAttaches(List<AttachmentEntity> attaches) {
        this.attaches = attaches;
    }

    public List<AttachmentEntity> getDevicePictures() {
        return devicePictures;
    }

    public void setDevicePictures(List<AttachmentEntity> devicePictures) {
        this.devicePictures = devicePictures;
    }

    public String getExhibitionPromotion() {
        return exhibitionPromotion;
    }

    public void setExhibitionPromotion(String exhibitionPromotion) {
        this.exhibitionPromotion = exhibitionPromotion;
    }

    public String getGiftDetails() {
        return giftDetails;
    }

    public void setGiftDetails(String giftDetails) {
        this.giftDetails = giftDetails;
    }

    public String getExpenseDescription() {
        return expenseDescription;
    }

    public void setExpenseDescription(String expenseDescription) {
        this.expenseDescription = expenseDescription;
    }

    public BigDecimal getTrainingFee() {
        return trainingFee;
    }

    public void setTrainingFee(BigDecimal trainingFee) {
        this.trainingFee = trainingFee;
    }

    public BigDecimal getNetTransactionPrice() {
        return netTransactionPrice;
    }

    public void setNetTransactionPrice(BigDecimal netTransactionPrice) {
        this.netTransactionPrice = netTransactionPrice;
    }

    public String getAccessoryGift() {
        return accessoryGift;
    }

    public void setAccessoryGift(String accessoryGift) {
        this.accessoryGift = accessoryGift;
    }

    public BigDecimal getOtherFee() {
        return otherFee;
    }

    public void setOtherFee(BigDecimal otherFee) {
        this.otherFee = otherFee;
    }

    public BigDecimal getFreight() {
        return freight;
    }

    public void setFreight(BigDecimal freight) {
        this.freight = freight;
    }

    public BigDecimal getCompanyLimitPrice() {
        return companyLimitPrice;
    }

    public void setCompanyLimitPrice(BigDecimal companyLimitPrice) {
        this.companyLimitPrice = companyLimitPrice;
    }

    public String getWhetherToClose() {
        return whetherToClose;
    }

    public void setWhetherToClose(String whetherToClose) {
        this.whetherToClose = whetherToClose;
    }

    @Override
    public JSONObject getJSONObject() {
        JSONObject obj = new JSONObject();
        obj.put("ID", this.getId());
        obj.put("FK_COMPANY_ID", this.getFkCompanyId());
        obj.put("COMPANY_NAME", this.getCompanyName());
        obj.put("HOUSE_NAME", this.getHouseName());
        obj.put("HOUSE_ADDRESS", this.getHouseAddress());
        obj.put("STATE", this.getState());
        obj.put("BUILDING_NUMBER", this.getBuildingNumber());
        obj.put("AREA", this.getArea());
        obj.put("REMARK", this.getRemark());
        obj.put("TYPE", this.getType());
        obj.put("BRAND_NAME", this.getBrandName());
        obj.put("STORE_ADDRESS", this.getStoreAddress());
        obj.put("MODEL_NAME", this.getModelName());
        obj.put("SEQUENCE", this.getSequence());
        obj.put("FACTORY_DATE", this.getFactoryDate());
        obj.put("DEL_FLAG", this.getDelFlag());
        obj.put("HOURS", this.getHours());
        obj.put("KILOMETERS", this.getKilometers());
        obj.put("REPLACEMENT_ID", this.getReplacementId());
        obj.put("MANUFACTURER", this.getManufacturer());
        obj.put("REPLACEMENT_TYPE", this.getReplacementType());
        obj.put("HOUSES_PROPERTY", this.getHousesProperty());
        obj.put("REPLACEMENT_PRICE", this.getReplacementPrice());
        obj.put("ESTIMATE_PRICE", this.getEstimatePrice());
        obj.put("REPLACEMENTS_NAME", this.getReplacementsName());
        obj.put("REGION_ID", this.getRegionId());
        obj.put("REGION_NAME", this.getRegionName());
        obj.put("REGION_MANAGER_ID", this.getRegionManagerId());
        obj.put("REGION_MANAGER_NAME", this.getRegionManagerName());
        obj.put("BIGREGION_MANAGER_ID", this.getBigregionManagerId());
        obj.put("BIGREGION_MANAGER_NAME", this.getBigregionManagerName());
        obj.put("SELL_PRICE", this.getSellPrice());
        obj.put("TRANSFER", this.getTransfer());
        obj.put("REPLACEMENT_SUBSIDY", this.getReplacementSubsidy());
        obj.put("OTHER_CONDITION", this.getOtherCondition());
        obj.put("CREATE_TIME", this.getCreateTime());
        obj.put("UPDATE_TIME", this.getUpdateTime());
        obj.put("DEVICE_ANNEX_NAME", this.getDeviceAnnexName());
        obj.put("DEVICE_ANNEX_URL", this.getDeviceAnnexUrl());
        obj.put("DEPARTURE", this.getDeparture());
        obj.put("DEPARTURE_CONTACT_NAME", this.getDepartureContactName());
        obj.put("DEPARTURE_CONTACT_TEL", this.getDepartureContactTel());
        obj.put("DESTINATION", this.getDestination());
        obj.put("DESTINATION_CONTACT_NAME", this.getDestinationContactName());
        obj.put("DESTINATION_CONTACT_TEL", this.getDestinationContactTel());
        obj.put("TRANSPORT_COMPANY", this.getTransportCompany());
        obj.put("TRA_COM_CONTACT_NAME", this.getTraComContactName());
        obj.put("TRA_COM_CONTACT_TEL", this.getTraComContactTel());
        obj.put("MODEL_CAR_LICENSE", this.getModelCarLicense());
        obj.put("DRIVER_NAME", this.getDriverName());
        obj.put("DRIVER_TEL", this.getDriverTel());
        obj.put("FREIGHT", this.getFreight());
        obj.put("DEDUCTION", this.getDeduction());
        obj.put("DEDUCTION_INSTRUCTIONS", this.getDeductionInstructions());
        obj.put("MODEL_CAR_PHOTO_NAME", this.getModelCarPhotoName());
        obj.put("MODEL_CAR_PHOTO_URL", this.getModelCarPhotoUrl());
        obj.put("DRIVER_CERTIFICATE_NAME", this.getDriverCertificateName());
        obj.put("DRIVER_CERTIFICATE_URL", this.getDriverCertificateUrl());
        obj.put("DEVICE_PHOTO_NAME", this.getDevicePhotoName());
        obj.put("DEVICE_PHOTO_URL", this.getDevicePhotoUrl());
        obj.put("TRANSPORT_STATE", this.getTransportState());
        obj.put("INSURANCE_EXPIRATION_DATE", this.getInsuranceExpirationDate());
        obj.put("FRAME_NUMBER", this.getFrameNumber());
        obj.put("EXHIBITION_PROMOTION", this.getExhibitionPromotion());
        obj.put("GIFT_DETAILS", this.getGiftDetails());
        obj.put("EXPENSE_DESCRIPTION", this.getExpenseDescription());
        obj.put("TRAINING_FEE", this.getTrainingFee());
        obj.put("NET_TRANSACTION_PRICE", this.getNetTransactionPrice());
        obj.put("ACCESSORY_GIFT", this.getAccessoryGift());
        obj.put("OTHER_FEE", this.getOtherFee());
        obj.put("COMPANY_LIMIT_PRICE", this.getCompanyLimitPrice());
        obj.put("REPLACEMENT_NUMBER", this.getReplacementNumber());
        obj.put("PRICE_OFFER", this.getPriceOffer());

        obj.put("AUDIT_NAME", this.getAuditName());
        obj.put("AUDIT_ID", this.getAuditId());
        obj.put("AUDIT_FLAG", this.getAuditFlag());
        obj.put("CREATE_USER_ID", this.getCreateUserId());
        obj.put("CREATE_USER_NAME", this.getCreateUserName());
        obj.put("UPDATE_USER_ID", this.getUpdateUserId());
        obj.put("UPDATE_USER_NAME", this.getUpdateUserName());
        obj.put("AUDIT_ADVISE", this.getAuditAdvise());
        obj.put("AUDIT_ROLE_NAME", this.getAuditRoleName());
        obj.put("AUDIT_TIME", this.getAuditTime());

        obj.put("RECENT_CONTACT_DATE", this.getRecentContactDate());
        obj.put("LATEST_WORKING_HOURS", this.getLatestWorkingHours());
        obj.put("DEVICE_SOURCE", this.getDeviceSource());
        obj.put("WARRANTY_STATE", this.getWarrantyState());
        obj.put("ADMINISTRATOR_NAME", this.getAdministratorName());
        obj.put("ADMINISTRATOR_PHONE", this.getAdministratorPhone());
        obj.put("OPERATOR_NAME", this.getOperatorName());
        obj.put("OPERATOR_PHONE", this.getOperatorPhone());
        obj.put("SERVICE_PERSONNEL", this.getServicePersonnel());
        obj.put("ENGINE_NUMBER", this.getEngineNumber());
        obj.put("NEXT_SERVICE_DATE", this.getNextServiceDate());
        obj.put("COOPERATION_TYPE", this.getCooperationType());
        obj.put("LOSS_MONEY", this.getLossMoney());
        obj.put("FUND_POSSESSION_COST", this.getFundPossessionCost());

        obj.put("CUSTOMER_NAME", this.getCustomerName());
        obj.put("REPLACEMENT_DEVICE_MODEL_NAME", this.getReplacementDeviceModelName());
        obj.put("REPLACEMENT_DEVICE_BRAND_NAME", this.getReplacementDeviceBrandName());
        obj.put("REPLACEMENT_DEVICE_SEQUENCE", this.getReplacementDeviceSequence());
        obj.put("WHETHER_TO_CLOSE", this.getWhetherToClose());

        return obj;
    }

    @Override
    public String getTableName() {
        return "T_DVC_DISPLACE";
    }

    @Override
    public JSONObject getJSONColumns() {
        JSONObject obj = new JSONObject();
        obj.put("ID", "id");
        obj.put("FK_COMPANY_ID", "fkCompanyId");
        obj.put("COMPANY_NAME", "companyName");
        obj.put("HOUSE_NAME", "houseName");
        obj.put("HOUSE_ADDRESS", "houseAddress");
        obj.put("STATE", "state");
        obj.put("BUILDING_NUMBER", "buildingNumber");
        obj.put("AREA", "area");
        obj.put("REMARK", "remark");
        obj.put("TYPE", "type");
        obj.put("BRAND_NAME", "brandName");
        obj.put("STORE_ADDRESS", "storeAddress");
        obj.put("MODEL_NAME", "modelName");
        obj.put("SEQUENCE", "sequence");
        obj.put("FACTORY_DATE", "factoryDate");
        obj.put("DEL_FLAG", "delFlag");
        obj.put("HOURS", "hours");
        obj.put("KILOMETERS", "kilometers");
        obj.put("REPLACEMENT_ID", "replacementId");
        obj.put("MANUFACTURER", "manufacturer");
        obj.put("REPLACEMENT_TYPE", "replacementType");
        obj.put("HOUSES_PROPERTY", "housesProperty");
        obj.put("REPLACEMENT_PRICE", "replacementPrice");
        obj.put("ESTIMATE_PRICE", "estimatePrice");
        obj.put("REPLACEMENTS_NAME", "replacementsName");
        obj.put("REGION_ID", "regionId");
        obj.put("REGION_NAME", "regionName");
        obj.put("REGION_MANAGER_ID", "regionManagerId");
        obj.put("REGION_MANAGER_NAME", "regionManagerName");
        obj.put("BIGREGION_MANAGER_ID", "bigregionManagerId");
        obj.put("BIGREGION_MANAGER_NAME", "bigregionManagerName");
        obj.put("SELL_PRICE", "sellPrice");
        obj.put("TRANSFER", "transfer");
        obj.put("REPLACEMENT_SUBSIDY", "replacementSubsidy");
        obj.put("OTHER_CONDITION", "otherCondition");
        obj.put("DEVICE_ANNEX_NAME", "deviceAnnexName");
        obj.put("DEVICE_ANNEX_URL", "deviceAnnexUrl");
        obj.put("DEPARTURE", "departure");
        obj.put("DEPARTURE_CONTACT_NAME", "departureContactName");
        obj.put("DEPARTURE_CONTACT_TEL", "departureContactTel");
        obj.put("DESTINATION", "destination");
        obj.put("DESTINATION_CONTACT_NAME", "destinationContactName");
        obj.put("DESTINATION_CONTACT_TEL", "destinationContactTel");
        obj.put("TRANSPORT_COMPANY", "transportCompany");
        obj.put("TRA_COM_CONTACT_NAME", "traComContactName");
        obj.put("TRA_COM_CONTACT_TEL", "traComContactTel");
        obj.put("MODEL_CAR_LICENSE", "modelCarLicense");
        obj.put("DRIVER_NAME", "driverName");
        obj.put("DRIVER_TEL", "driverTel");
        obj.put("DEDUCTION", "deduction");
        obj.put("DEDUCTION_INSTRUCTIONS", "deductionInstructions");
        obj.put("MODEL_CAR_PHOTO_NAME", "modelCarPhotoName");
        obj.put("MODEL_CAR_PHOTO_URL", "modelCarPhotoUrl");
        obj.put("DRIVER_CERTIFICATE_NAME", "driverCertificateName");
        obj.put("DRIVER_CERTIFICATE_URL", "driverCertificateUrl");
        obj.put("DEVICE_PHOTO_NAME", "devicePhotoName");
        obj.put("DEVICE_PHOTO_URL", "devicePhotoUrl");
        obj.put("TRANSPORT_STATE", "transportState");
        obj.put("INSURANCE_EXPIRATION_DATE", "insuranceExpirationDate");
        obj.put("FRAME_NUMBER", "frameNumber");
        obj.put("FREIGHT", "freight");
        obj.put("EXHIBITION_PROMOTION", "exhibitionPromotion");
        obj.put("GIFT_DETAILS", "giftDetails");
        obj.put("EXPENSE_DESCRIPTION", "expenseDescription");
        obj.put("TRAINING_FEE", "trainingFee");
        obj.put("NET_TRANSACTION_PRICE", "netTransactionPrice");
        obj.put("ACCESSORY_GIFT", "accessoryGift");
        obj.put("OTHER_FEE", "otherFee");
        obj.put("COMPANY_LIMIT_PRICE", "companyLimitPrice");
        obj.put("REPLACEMENT_NUMBER", "replacementNumber");
        obj.put("PRICE_OFFER", "priceOffer");


        obj.put("AUDIT_NAME", "auditName");
        obj.put("AUDIT_ID", "auditId");
        obj.put("AUDIT_FLAG", "auditFlag");
        obj.put("CREATE_USER_ID", "createUserId");
        obj.put("CREATE_USER_NAME", "createUserName");
        obj.put("UPDATE_USER_ID", "updateUserId");
        obj.put("UPDATE_USER_NAME", "updateUserName");
        obj.put("AUDIT_ADVISE", "auditAdvise");
        obj.put("AUDIT_ROLE_NAME", "auditRoleName");
        obj.put("AUDIT_TIME", "auditTime");
        obj.put("CREATE_TIME", "createTime");


        obj.put("RECENT_CONTACT_DATE", "recentContactDate");
        obj.put("LATEST_WORKING_HOURS", "latestWorkingHours");
        obj.put("DEVICE_SOURCE", "deviceSource");
        obj.put("WARRANTY_STATE", "warrantyState");
        obj.put("ADMINISTRATOR_NAME", "administratorName");
        obj.put("ADMINISTRATOR_PHONE", "administratorPhone");
        obj.put("OPERATOR_NAME", "operatorName");
        obj.put("OPERATOR_PHONE", "operatorPhone");
        obj.put("SERVICE_PERSONNEL", "servicePersonnel");
        obj.put("ENGINE_NUMBER", "engineNumber");
        obj.put("NEXT_SERVICE_DATE", "nextServiceDate");
        obj.put("COOPERATION_TYPE", "cooperationType");
        obj.put("LOSS_MONEY", "lossMoney");
        obj.put("FUND_POSSESSION_COST", "fundPossessionCost");

        obj.put("CUSTOMER_NAME", "customerName");
        obj.put("REPLACEMENT_DEVICE_MODEL_NAME", "replacementDeviceModelName");
        obj.put("REPLACEMENT_DEVICE_BRAND_NAME", "replacementDeviceBrandName");
        obj.put("REPLACEMENT_DEVICE_SEQUENCE", "replacementDeviceSequence");
        obj.put("WHETHER_TO_CLOSE", "whetherToClose");

        return obj;
    }
}
